<%-- 
    Document   : deleteEmployee
    Created on : May 5, 2013, 11:40:58 PM
    Author     : Byung Park
--%>

<%@page import="java.sql.ResultSet"%>
<%@page import="db.UserDAO"%>
<%@page import="java.sql.Statement"%>
<%@page import="java.sql.Connection"%>
<%@page import="db.DB"%>
<%

    String id=request.getParameter("id");
    int no=Integer.parseInt(id);
    int sumcount=0;
    try {
    DB data = new DB();
    Connection conn =  data.getConnection();
    Statement st = conn.createStatement();
    st.executeUpdate("DELETE FROM Users WHERE id = '"+no+"'");
    response.sendRedirect("employeeList.jsp");
    }
    catch(Exception e){}
%>
